SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='L'
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Land / Acres page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Prime development opportunity in Enfield's TIF district — 2.5 acres with 340 feet of frontage and a curb cut on Route 4, plus an existing Class IV road along the east boundary that could serve as a secondary driveway or access point. US Route 4 carries an average of 7,472 vehicles per day (2025 AADT), split roughly evenly between eastbound (3,699) and westbound (3,774) traffic — solid visibility for a commercial user. Town water and sewer available at the street. Zoned Community Business, supporting a range of commercial and mixed-use development. A conceptual design for a mixed-use building is available for review.